Reporte de Perfil de Clusterización DBSCAN

Dataset statistics

Number of variables	17
Number of observations	189516
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	82.9 MiB
Average record size in memory	458.7 B

Variable types

Numeric	10
Categorical	6
Text	1

Alerts

`Cluster_DBSCAN` is highly overall correlated with `add_to_cart_order` and 1 other fields	High correlation
`add_to_cart_order` is highly overall correlated with `Cluster_DBSCAN`	High correlation
`day` is highly overall correlated with `order_dow`	High correlation
`department` is highly overall correlated with `department_id`	High correlation
`department_id` is highly overall correlated with `department`	High correlation
`max_order` is highly overall correlated with `order_number` and 1 other fields	High correlation
`order_dow` is highly overall correlated with `day`	High correlation
`order_hour_of_day` is highly overall correlated with `order_time_list`	High correlation
`order_number` is highly overall correlated with `max_order` and 1 other fields	High correlation
`order_number_group` is highly overall correlated with `max_order` and 1 other fields	High correlation
`order_time_list` is highly overall correlated with `order_hour_of_day`	High correlation
`reordered` is highly overall correlated with `Cluster_DBSCAN`	High correlation
`order_dow` has 36565 (19.3%) zeros	Zeros
`days_since_prior_order` has 2723 (1.4%) zeros	Zeros

Reproduction

Analysis started	2024-11-07 01:03:50.134226
Analysis finished	2024-11-07 01:04:06.882990
Duration	16.75 seconds
Software version	ydata-profiling vv4.12.0
Download configuration	config.json

order_id
Real number (ℝ)

Distinct	106346
Distinct (%)	56.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1707147.1

Minimum	10
Maximum	3420991
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.9 MiB

Quantile statistics

Minimum	10
5-th percentile	173219.75
Q1	850455.5
median	1706160
Q3	2558574.8
95-th percentile	3243192
Maximum	3420991
Range	3420981
Interquartile range (IQR)	1708119.2

Descriptive statistics

Standard deviation	985588.47
Coefficient of variation (CV)	0.57733074
Kurtosis	-1.199088
Mean	1707147.1
Median Absolute Deviation (MAD)	853927
Skewness	0.0034271321
Sum	3.2353168 × 10¹¹
Variance	9.7138463 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
45973	15	< 0.1%
790903	14	< 0.1%
2869702	12	< 0.1%
2988851	12	< 0.1%
2621625	11	< 0.1%
2352182	11	< 0.1%
432719	11	< 0.1%
1019050	11	< 0.1%
293169	10	< 0.1%
3269518	10	< 0.1%
Other values (106336)	189399	99.9%

Value	Count	Frequency (%)
10	2	< 0.1%
11	1	< 0.1%
38	1	< 0.1%
56	1	< 0.1%
64	1	< 0.1%
147	2	< 0.1%
227	1	< 0.1%
243	1	< 0.1%
372	1	< 0.1%
471	3	< 0.1%

Value	Count	Frequency (%)
3420991	3	< 0.1%
3420952	1	< 0.1%
3420910	2	< 0.1%
3420899	1	< 0.1%
3420898	1	< 0.1%
3420861	2	< 0.1%
3420771	4	< 0.1%
3420760	3	< 0.1%
3420584	2	< 0.1%
3420542	2	< 0.1%

user_id
Real number (ℝ)

Distinct	68153
Distinct (%)	36.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	103102.85

Minimum	2
Maximum	206209
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.9 MiB

Quantile statistics

Minimum	2
5-th percentile	10750
Q1	51690
median	102860.5
Q3	154590.5
95-th percentile	195822
Maximum	206209
Range	206207
Interquartile range (IQR)	102900.5

Descriptive statistics

Standard deviation	59479.667
Coefficient of variation (CV)	0.57689647
Kurtosis	-1.2034919
Mean	103102.85
Median Absolute Deviation (MAD)	51467.5
Skewness	0.0061718094
Sum	1.9539639 × 10¹⁰
Variance	3.5378308 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
176478	52	< 0.1%
126305	41	< 0.1%
129928	40	< 0.1%
115495	36	< 0.1%
31903	34	< 0.1%
97816	28	< 0.1%
47076	28	< 0.1%
15503	28	< 0.1%
203166	28	< 0.1%
28453	27	< 0.1%
Other values (68143)	189174	99.8%

Value	Count	Frequency (%)
2	3	< 0.1%
3	1	< 0.1%
7	7	< 0.1%
10	3	< 0.1%
13	3	< 0.1%
17	1	< 0.1%
21	1	< 0.1%
22	2	< 0.1%
31	1	< 0.1%
35	3	< 0.1%

Value	Count	Frequency (%)
206209	5	< 0.1%
206208	2	< 0.1%
206206	1	< 0.1%
206204	1	< 0.1%
206201	3	< 0.1%
206197	1	< 0.1%
206193	1	< 0.1%
206189	1	< 0.1%
206187	1	< 0.1%
206186	1	< 0.1%

order_number
Real number (ℝ)

High correlation

Distinct	99
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18.203893

Minimum	2
Maximum	100
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.9 MiB

Quantile statistics

Minimum	2
5-th percentile	2
Q1	6
median	12
Q3	25
95-th percentile	55
Maximum	100
Range	98
Interquartile range (IQR)	19

Descriptive statistics

Standard deviation	17.555727
Coefficient of variation (CV)	0.96439412
Kurtosis	3.1766306
Mean	18.203893
Median Absolute Deviation (MAD)	8
Skewness	1.7399547
Sum	3449929
Variance	308.20356
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	12272	6.5%
3	12133	6.4%
4	11880	6.3%
5	10556	5.6%
6	9298	4.9%
7	8560	4.5%
8	7577	4.0%
9	7052	3.7%
10	6521	3.4%
11	6266	3.3%
Other values (89)	97401	51.4%

Value	Count	Frequency (%)
2	12272	6.5%
3	12133	6.4%
4	11880	6.3%
5	10556	5.6%
6	9298	4.9%
7	8560	4.5%
8	7577	4.0%
9	7052	3.7%
10	6521	3.4%
11	6266	3.3%

Value	Count	Frequency (%)
100	53	< 0.1%
99	47	< 0.1%
98	79	< 0.1%
97	92	< 0.1%
96	108	0.1%
95	71	< 0.1%
94	91	< 0.1%
93	97	0.1%
92	123	0.1%
91	81	< 0.1%

order_dow
Real number (ℝ)

High correlation Zeros

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.7382279

Minimum	0
Maximum	6
Zeros	36565
Zeros (%)	19.3%
Negative	0
Negative (%)	0.0%
Memory size	6.9 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	3
Q3	5
95-th percentile	6
Maximum	6
Range	6
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.0909175
Coefficient of variation (CV)	0.76360245
Kurtosis	-1.3354969
Mean	2.7382279
Median Absolute Deviation (MAD)	2
Skewness	0.17783666
Sum	518938
Variance	4.3719362
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
0	36565	19.3%
1	32668	17.2%
6	26156	13.8%
5	24908	13.1%
2	24802	13.1%
3	22478	11.9%
4	21939	11.6%

Value	Count	Frequency (%)
0	36565	19.3%
1	32668	17.2%
2	24802	13.1%
3	22478	11.9%
4	21939	11.6%
5	24908	13.1%
6	26156	13.8%

Value	Count	Frequency (%)
6	26156	13.8%
5	24908	13.1%
4	21939	11.6%
3	22478	11.9%
2	24802	13.1%
1	32668	17.2%
0	36565	19.3%

order_hour_of_day
Real number (ℝ)

High correlation

Distinct	24
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13.439678

Minimum	0
Maximum	23
Zeros	1271
Zeros (%)	0.7%
Negative	0
Negative (%)	0.0%
Memory size	6.9 MiB

Quantile statistics

Minimum	0
5-th percentile	7
Q1	10
median	13
Q3	16
95-th percentile	21
Maximum	23
Range	23
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	4.2434462
Coefficient of variation (CV)	0.31574017
Kurtosis	-0.020741059
Mean	13.439678
Median Absolute Deviation (MAD)	3
Skewness	-0.037719742
Sum	2547034
Variance	18.006835
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
10	16215	8.6%
11	16028	8.5%
14	15840	8.4%
15	15756	8.3%
13	15513	8.2%
12	15286	8.1%
16	14704	7.8%
9	14307	7.5%
17	12100	6.4%
8	9889	5.2%
Other values (14)	43878	23.2%

Value	Count	Frequency (%)
0	1271	0.7%
1	663	0.3%
2	349	0.2%
3	284	0.1%
4	279	0.1%
5	566	0.3%
6	1752	0.9%
7	5184	2.7%
8	9889	5.2%
9	14307	7.5%

Value	Count	Frequency (%)
23	2356	1.2%
22	3751	2.0%
21	4661	2.5%
20	5991	3.2%
19	7288	3.8%
18	9483	5.0%
17	12100	6.4%
16	14704	7.8%
15	15756	8.3%
14	15840	8.4%

days_since_prior_order
Real number (ℝ)

Zeros

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.420603

Minimum	0
Maximum	30
Zeros	2723
Zeros (%)	1.4%
Negative	0
Negative (%)	0.0%
Memory size	6.9 MiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	5
median	8
Q3	15
95-th percentile	30
Maximum	30
Range	30
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	8.9802529
Coefficient of variation (CV)	0.78632038
Kurtosis	-0.24566243
Mean	11.420603
Median Absolute Deviation (MAD)	4
Skewness	0.99706993
Sum	2164387
Variance	80.644943
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
7	21367	11.3%
30	21249	11.2%
6	15625	8.2%
5	12835	6.8%
4	12417	6.6%
8	11970	6.3%
3	11293	6.0%
2	8728	4.6%
9	7591	4.0%
14	6430	3.4%
Other values (21)	60011	31.7%

Value	Count	Frequency (%)
0	2723	1.4%
1	5930	3.1%
2	8728	4.6%
3	11293	6.0%
4	12417	6.6%
5	12835	6.8%
6	15625	8.2%
7	21367	11.3%
8	11970	6.3%
9	7591	4.0%

Value	Count	Frequency (%)
30	21249	11.2%
29	1138	0.6%
28	1701	0.9%
27	1319	0.7%
26	1100	0.6%
25	1155	0.6%
24	1295	0.7%
23	1380	0.7%
22	2002	1.1%
21	2843	1.5%

product_id
Real number (ℝ)

Distinct	134
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	71.096145

Minimum	1
Maximum	134
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.9 MiB

Quantile statistics

Minimum	1
5-th percentile	16
Q1	31
median	83
Q3	107
95-th percentile	123
Maximum	134
Range	133
Interquartile range (IQR)	76

Descriptive statistics

Standard deviation	38.210891
Coefficient of variation (CV)	0.53745377
Kurtosis	-1.3246676
Mean	71.096145
Median Absolute Deviation (MAD)	33
Skewness	-0.16461665
Sum	13473857
Variance	1460.0722
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
24	21490	11.3%
83	19909	10.5%
123	10208	5.4%
120	8567	4.5%
21	5792	3.1%
84	5375	2.8%
115	4911	2.6%
107	4172	2.2%
91	3658	1.9%
112	3364	1.8%
Other values (124)	102070	53.9%

Value	Count	Frequency (%)
1	413	0.2%
2	472	0.2%
3	2832	1.5%
4	1160	0.6%
5	363	0.2%
6	209	0.1%
7	192	0.1%
8	197	0.1%
9	1261	0.7%
10	52	< 0.1%

Value	Count	Frequency (%)
134	53	< 0.1%
133	104	0.1%
132	35	< 0.1%
131	1563	0.8%
130	942	0.5%
129	1105	0.6%
128	1129	0.6%
127	245	0.1%
126	101	0.1%
125	236	0.1%

add_to_cart_order
Real number (ℝ)

High correlation

Distinct	84
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8.3662857

Minimum	1
Maximum	135
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.9 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	6
Q3	11
95-th percentile	22
Maximum	135
Range	134
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	7.159101
Coefficient of variation (CV)	0.8557084
Kurtosis	6.4088486
Mean	8.3662857
Median Absolute Deviation (MAD)	4
Skewness	1.8695087
Sum	1585545
Variance	51.252727
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	18691	9.9%
2	17982	9.5%
3	16621	8.8%
4	15642	8.3%
5	14338	7.6%
6	12851	6.8%
7	11585	6.1%
8	10307	5.4%
9	9222	4.9%
10	7925	4.2%
Other values (74)	54352	28.7%

Value	Count	Frequency (%)
1	18691	9.9%
2	17982	9.5%
3	16621	8.8%
4	15642	8.3%
5	14338	7.6%
6	12851	6.8%
7	11585	6.1%
8	10307	5.4%
9	9222	4.9%
10	7925	4.2%

Value	Count	Frequency (%)
135	1	< 0.1%
120	1	< 0.1%
93	2	< 0.1%
91	1	< 0.1%
90	2	< 0.1%
87	1	< 0.1%
85	1	< 0.1%
84	1	< 0.1%
78	2	< 0.1%
77	2	< 0.1%

reordered
Categorical

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	16.0 MiB

1	119155
0	70361

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	189516
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	0
3rd row	0
4th row	1
5th row	0

Common Values

Value	Count	Frequency (%)
1	119155	62.9%
0	70361	37.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	119155	62.9%
0	70361	37.1%

Most occurring characters

Value	Count	Frequency (%)
1	119155	62.9%
0	70361	37.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	189516	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	119155	62.9%
0	70361	37.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	189516	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	119155	62.9%
0	70361	37.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	189516	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	119155	62.9%
0	70361	37.1%

department_id
Real number (ℝ)

High correlation

Distinct	21
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.9318158

Minimum	1
Maximum	21
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.9 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	4
median	9
Q3	16
95-th percentile	19
Maximum	21
Range	20
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	6.2830562
Coefficient of variation (CV)	0.63261909
Kurtosis	-1.5613321
Mean	9.9318158
Median Absolute Deviation (MAD)	5
Skewness	0.14969704
Sum	1882238
Variance	39.476796
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=21)

Value	Count	Frequency (%)
4	55392	29.2%
16	31697	16.7%
19	16986	9.0%
7	15810	8.3%
1	13005	6.9%
13	10880	5.7%
3	6843	3.6%
15	6184	3.3%
20	6093	3.2%
9	5048	2.7%
Other values (11)	21578	11.4%

Value	Count	Frequency (%)
1	13005	6.9%
2	209	0.1%
3	6843	3.6%
4	55392	29.2%
5	866	0.5%
6	1553	0.8%
7	15810	8.3%
8	562	0.3%
9	5048	2.7%
10	204	0.1%

Value	Count	Frequency (%)
21	461	0.2%
20	6093	3.2%
19	16986	9.0%
18	2463	1.3%
17	4324	2.3%
16	31697	16.7%
15	6184	3.3%
14	4173	2.2%
13	10880	5.7%
12	4148	2.2%

department
Categorical

High correlation

Distinct	21
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	17.2 MiB

produce	55392
dairy eggs	31697
snacks	16986
beverages	15810
frozen	13005
Other values (16)	56626

Length

Max length	15
Median length	13
Mean length	8.0003641
Min length	4

Characters and Unicode

Total characters	1516197
Distinct characters	23
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	dairy eggs
2nd row	canned goods
3rd row	canned goods
4th row	produce
5th row	bakery

Common Values

Value	Count	Frequency (%)
produce	55392	29.2%
dairy eggs	31697	16.7%
snacks	16986	9.0%
beverages	15810	8.3%
frozen	13005	6.9%
pantry	10880	5.7%
bakery	6843	3.6%
canned goods	6184	3.3%
deli	6093	3.2%
dry goods pasta	5048	2.7%
Other values (11)	21578	11.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
produce	55392	22.7%
dairy	31697	13.0%
eggs	31697	13.0%
snacks	16986	7.0%
beverages	15810	6.5%
frozen	13005	5.3%
goods	11232	4.6%
pantry	10880	4.5%
bakery	6843	2.8%
canned	6184	2.5%
Other values (16)	44530	18.2%

Most occurring characters

Value	Count	Frequency (%)
e	193454	12.8%
r	149840	9.9%
a	126803	8.4%
d	124118	8.2%
s	116966	7.7%
o	113914	7.5%
g	90897	6.0%
c	82043	5.4%
p	74497	4.9%
n	60974	4.0%
Other values (13)	382691	25.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1461457	96.4%
Space Separator	54740	3.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	193454	13.2%
r	149840	10.3%
a	126803	8.7%
d	124118	8.5%
s	116966	8.0%
o	113914	7.8%
g	90897	6.2%
c	82043	5.6%
p	74497	5.1%
n	60974	4.2%
Other values (12)	327951	22.4%

Space Separator

Value	Count	Frequency (%)
	54740	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1461457	96.4%
Common	54740	3.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	193454	13.2%
r	149840	10.3%
a	126803	8.7%
d	124118	8.5%
s	116966	8.0%
o	113914	7.8%
g	90897	6.2%
c	82043	5.6%
p	74497	5.1%
n	60974	4.2%
Other values (12)	327951	22.4%

Common

Value	Count	Frequency (%)
	54740	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1516197	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	193454	12.8%
r	149840	9.9%
a	126803	8.4%
d	124118	8.2%
s	116966	7.7%
o	113914	7.5%
g	90897	6.0%
c	82043	5.4%
p	74497	4.9%
n	60974	4.0%
Other values (13)	382691	25.2%

product_name
Text

Distinct	134
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	18.4 MiB

Length

Max length	29
Median length	23
Mean length	14.420223
Min length	3

Characters and Unicode

Total characters	2732863
Distinct characters	26
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	specialty cheeses
2nd row	canned jarred vegetables
3rd row	soup broth bouillon
4th row	fresh fruits
5th row	breakfast bakery

Value	Count	Frequency (%)
fresh	45870	11.4%
vegetables	31934	7.9%
fruits	31794	7.9%
packaged	18612	4.6%
frozen	10068	2.5%
water	9822	2.4%
yogurt	8567	2.1%
ice	5941	1.5%
cheese	5792	1.4%
milk	5375	1.3%
Other values (194)	228628	56.8%

Most occurring characters

Value	Count	Frequency (%)
e	389355	14.2%
s	258706	9.5%
r	232201	8.5%
a	214506	7.8%
	212887	7.8%
t	160486	5.9%
f	118125	4.3%
i	109651	4.0%
o	102984	3.8%
g	102195	3.7%
Other values (16)	831767	30.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2519976	92.2%
Space Separator	212887	7.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	389355	15.5%
s	258706	10.3%
r	232201	9.2%
a	214506	8.5%
t	160486	6.4%
f	118125	4.7%
i	109651	4.4%
o	102984	4.1%
g	102195	4.1%
c	97165	3.9%
Other values (15)	734602	29.2%

Space Separator

Value	Count	Frequency (%)
	212887	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2519976	92.2%
Common	212887	7.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	389355	15.5%
s	258706	10.3%
r	232201	9.2%
a	214506	8.5%
t	160486	6.4%
f	118125	4.7%
i	109651	4.4%
o	102984	4.1%
g	102195	4.1%
c	97165	3.9%
Other values (15)	734602	29.2%

Common

Value	Count	Frequency (%)
	212887	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2732863	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	389355	14.2%
s	258706	9.5%
r	232201	8.5%
a	214506	7.8%
	212887	7.8%
t	160486	5.9%
f	118125	4.3%
i	109651	4.0%
o	102984	3.8%
g	102195	3.7%
Other values (16)	831767	30.4%

day
Categorical

High correlation

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	17.1 MiB

Monday	36565
Tuesday	32668
Sunday	26156
Saturday	24908
Wednesday	24802
Other values (2)	44417

Length

Max length	9
Median length	8
Mean length	7.0650605
Min length	6

Characters and Unicode

Total characters	1338942
Distinct characters	17
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Wednesday
2nd row	Thursday
3rd row	Friday
4th row	Friday
5th row	Wednesday

Common Values

Value	Count	Frequency (%)
Monday	36565	19.3%
Tuesday	32668	17.2%
Sunday	26156	13.8%
Saturday	24908	13.1%
Wednesday	24802	13.1%
Thursday	22478	11.9%
Friday	21939	11.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
monday	36565	19.3%
tuesday	32668	17.2%
sunday	26156	13.8%
saturday	24908	13.1%
wednesday	24802	13.1%
thursday	22478	11.9%
friday	21939	11.6%

Most occurring characters

Value	Count	Frequency (%)
a	214424	16.0%
d	214318	16.0%
y	189516	14.2%
u	106210	7.9%
n	87523	6.5%
e	82272	6.1%
s	79948	6.0%
r	69325	5.2%
T	55146	4.1%
S	51064	3.8%
Other values (7)	189196	14.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1149426	85.8%
Uppercase Letter	189516	14.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	214424	18.7%
d	214318	18.6%
y	189516	16.5%
u	106210	9.2%
n	87523	7.6%
e	82272	7.2%
s	79948	7.0%
r	69325	6.0%
o	36565	3.2%
t	24908	2.2%
Other values (2)	44417	3.9%

Uppercase Letter

Value	Count	Frequency (%)
T	55146	29.1%
S	51064	26.9%
M	36565	19.3%
W	24802	13.1%
F	21939	11.6%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1338942	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	214424	16.0%
d	214318	16.0%
y	189516	14.2%
u	106210	7.9%
n	87523	6.5%
e	82272	6.1%
s	79948	6.0%
r	69325	5.2%
T	55146	4.1%
S	51064	3.8%
Other values (7)	189196	14.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1338942	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	214424	16.0%
d	214318	16.0%
y	189516	14.2%
u	106210	7.9%
n	87523	6.5%
e	82272	6.1%
s	79948	6.0%
r	69325	5.2%
T	55146	4.1%
S	51064	3.8%
Other values (7)	189196	14.1%

order_time_list
Categorical

High correlation

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	17.1 MiB

Morning	78661
Afternoon	73913
Night	31174
Dawn	5768

Length

Max length	9
Median length	7
Mean length	7.3597269
Min length	4

Characters and Unicode

Total characters	1394786
Distinct characters	15
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Afternoon
2nd row	Afternoon
3rd row	Night
4th row	Morning
5th row	Morning

Common Values

Value	Count	Frequency (%)
Morning	78661	41.5%
Afternoon	73913	39.0%
Night	31174	16.4%
Dawn	5768	3.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
morning	78661	41.5%
afternoon	73913	39.0%
night	31174	16.4%
dawn	5768	3.0%

Most occurring characters

Value	Count	Frequency (%)
n	310916	22.3%
o	226487	16.2%
r	152574	10.9%
i	109835	7.9%
g	109835	7.9%
t	105087	7.5%
M	78661	5.6%
A	73913	5.3%
f	73913	5.3%
e	73913	5.3%
Other values (5)	79652	5.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1205270	86.4%
Uppercase Letter	189516	13.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
n	310916	25.8%
o	226487	18.8%
r	152574	12.7%
i	109835	9.1%
g	109835	9.1%
t	105087	8.7%
f	73913	6.1%
e	73913	6.1%
h	31174	2.6%
a	5768	0.5%

Uppercase Letter

Value	Count	Frequency (%)
M	78661	41.5%
A	73913	39.0%
N	31174	16.4%
D	5768	3.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1394786	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
n	310916	22.3%
o	226487	16.2%
r	152574	10.9%
i	109835	7.9%
g	109835	7.9%
t	105087	7.5%
M	78661	5.6%
A	73913	5.3%
f	73913	5.3%
e	73913	5.3%
Other values (5)	79652	5.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1394786	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
n	310916	22.3%
o	226487	16.2%
r	152574	10.9%
i	109835	7.9%
g	109835	7.9%
t	105087	7.5%
M	78661	5.6%
A	73913	5.3%
f	73913	5.3%
e	73913	5.3%
Other values (5)	79652	5.7%

max_order
Real number (ℝ)

High correlation

Distinct	99
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	26.597153

Minimum	2
Maximum	100
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	6.9 MiB

Quantile statistics

Minimum	2
5-th percentile	3
Q1	8
median	19
Q3	39
95-th percentile	78
Maximum	100
Range	98
Interquartile range (IQR)	31

Descriptive statistics

Standard deviation	23.092888
Coefficient of variation (CV)	0.86824661
Kurtosis	0.84836213
Mean	26.597153
Median Absolute Deviation (MAD)	13
Skewness	1.2140408
Sum	5040586
Variance	533.28146
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4	7982	4.2%
3	7412	3.9%
5	7332	3.9%
2	6741	3.6%
6	6601	3.5%
7	6188	3.3%
8	5718	3.0%
9	5410	2.9%
10	5031	2.7%
11	5024	2.7%
Other values (89)	126077	66.5%

Value	Count	Frequency (%)
2	6741	3.6%
3	7412	3.9%
4	7982	4.2%
5	7332	3.9%
6	6601	3.5%
7	6188	3.3%
8	5718	3.0%
9	5410	2.9%
10	5031	2.7%
11	5024	2.7%

Value	Count	Frequency (%)
100	323	0.2%
99	468	0.2%
98	535	0.3%
97	431	0.2%
96	526	0.3%
95	361	0.2%
94	352	0.2%
93	418	0.2%
92	352	0.2%
91	302	0.2%

order_number_group
Categorical

High correlation

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	17.7 MiB

1-20 order	98479
21-40 order	47166
41-60 order	24558
61-80 order	11103
81-100 order	8210

Length

Max length	12
Median length	10
Mean length	10.523687
Min length	10

Characters and Unicode

Total characters	1994407
Distinct characters	12
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1-20 order
2nd row	21-40 order
3rd row	21-40 order
4th row	41-60 order
5th row	21-40 order

Common Values

Value	Count	Frequency (%)
1-20 order	98479	52.0%
21-40 order	47166	24.9%
41-60 order	24558	13.0%
61-80 order	11103	5.9%
81-100 order	8210	4.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
order	189516	50.0%
1-20	98479	26.0%
21-40	47166	12.4%
41-60	24558	6.5%
61-80	11103	2.9%
81-100	8210	2.2%

Most occurring characters

Value	Count	Frequency (%)
r	379032	19.0%
1	197726	9.9%
0	197726	9.9%
-	189516	9.5%
	189516	9.5%
o	189516	9.5%
d	189516	9.5%
e	189516	9.5%
2	145645	7.3%
4	71724	3.6%
Other values (2)	54974	2.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	947580	47.5%
Decimal Number	667795	33.5%
Dash Punctuation	189516	9.5%
Space Separator	189516	9.5%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	197726	29.6%
0	197726	29.6%
2	145645	21.8%
4	71724	10.7%
6	35661	5.3%
8	19313	2.9%

Lowercase Letter

Value	Count	Frequency (%)
r	379032	40.0%
o	189516	20.0%
d	189516	20.0%
e	189516	20.0%

Dash Punctuation

Value	Count	Frequency (%)
-	189516	100.0%

Space Separator

Value	Count	Frequency (%)
	189516	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1046827	52.5%
Latin	947580	47.5%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	197726	18.9%
0	197726	18.9%
-	189516	18.1%
	189516	18.1%
2	145645	13.9%
4	71724	6.9%
6	35661	3.4%
8	19313	1.8%

Latin

Value	Count	Frequency (%)
r	379032	40.0%
o	189516	20.0%
d	189516	20.0%
e	189516	20.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1994407	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	379032	19.0%
1	197726	9.9%
0	197726	9.9%
-	189516	9.5%
	189516	9.5%
o	189516	9.5%
d	189516	9.5%
e	189516	9.5%
2	145645	7.3%
4	71724	3.6%
Other values (2)	54974	2.8%

Cluster_DBSCAN
Categorical

High correlation

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	16.0 MiB

0	119133
1	70346
-1	37

Length

Max length	2
Median length	1
Mean length	1.0001952
Min length	1

Characters and Unicode

Total characters	189553
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	1
3rd row	1
4th row	0
5th row	1

Common Values

Value	Count	Frequency (%)
0	119133	62.9%
1	70346	37.1%
-1	37	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	119133	62.9%
1	70383	37.1%

Most occurring characters

Value	Count	Frequency (%)
0	119133	62.8%
1	70383	37.1%
-	37	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	189516	> 99.9%
Dash Punctuation	37	< 0.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	119133	62.9%
1	70383	37.1%

Dash Punctuation

Value	Count	Frequency (%)
-	37	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	189553	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	119133	62.8%
1	70383	37.1%
-	37	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	189553	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	119133	62.8%
1	70383	37.1%
-	37	< 0.1%

	Cluster_DBSCAN	add_to_cart_order	day	days_since_prior_order	department	department_id	max_order	order_dow	order_hour_of_day	order_id	order_number	order_number_group	order_time_list	product_id	reordered	user_id
Cluster_DBSCAN	1.000	0.513	0.013	0.100	0.152	0.120	0.174	0.013	0.040	0.006	0.195	0.153	0.033	0.069	1.000	0.007
add_to_cart_order	0.513	1.000	0.015	0.077	0.034	0.015	-0.009	-0.016	-0.016	-0.004	-0.005	0.014	0.023	0.004	0.109	0.000
day	0.013	0.015	1.000	0.054	0.025	0.020	0.027	1.000	0.029	0.007	0.018	0.031	0.033	0.011	0.015	0.009
days_since_prior_order	0.100	0.077	0.054	1.000	0.019	0.003	-0.493	-0.042	-0.006	-0.001	-0.386	0.266	0.032	0.004	0.141	0.001
department	0.152	0.034	0.025	0.019	1.000	1.000	0.021	0.025	0.014	0.002	0.018	0.030	0.017	0.438	0.215	0.006
department_id	0.120	0.015	0.020	0.003	1.000	1.000	0.008	0.005	-0.011	-0.004	0.003	0.022	0.013	0.022	0.169	-0.000
max_order	0.174	-0.009	0.027	-0.493	0.021	0.008	1.000	0.020	-0.048	0.002	0.780	0.975	0.029	0.001	0.246	-0.006
order_dow	0.013	-0.016	1.000	-0.042	0.025	0.005	0.020	1.000	0.012	0.004	0.013	0.031	0.033	0.000	0.015	0.001
order_hour_of_day	0.040	-0.016	0.029	-0.006	0.014	-0.011	-0.048	0.012	1.000	-0.001	-0.038	0.031	0.836	0.002	0.036	-0.001
order_id	0.006	-0.004	0.007	-0.001	0.002	-0.004	0.002	0.004	-0.001	1.000	0.004	0.006	0.007	0.000	0.000	0.004
order_number	0.195	-0.005	0.018	-0.386	0.018	0.003	0.780	0.013	-0.038	0.004	1.000	0.552	0.025	0.001	0.275	-0.005
order_number_group	0.153	0.014	0.031	0.266	0.030	0.022	0.975	0.031	0.031	0.006	0.552	1.000	0.027	0.020	0.216	0.018
order_time_list	0.033	0.023	0.033	0.032	0.017	0.013	0.029	0.033	0.836	0.007	0.025	0.027	1.000	0.009	0.023	0.009
product_id	0.069	0.004	0.011	0.004	0.438	0.022	0.001	0.000	0.002	0.000	0.001	0.020	0.009	1.000	0.098	0.002
reordered	1.000	0.109	0.015	0.141	0.215	0.169	0.246	0.015	0.036	0.000	0.275	0.216	0.023	0.098	1.000	0.000
user_id	0.007	0.000	0.009	0.001	0.006	-0.000	-0.006	0.001	-0.001	0.004	-0.005	0.018	0.009	0.002	0.000	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

	order_id	user_id	order_number	order_dow	order_hour_of_day	days_since_prior_order	product_id	add_to_cart_order	reordered	department_id	department	product_name	day	order_time_list	max_order	order_number_group	Cluster_DBSCAN
1083214	700028	169733	14	2	14	7.0	2	12	1	16	dairy eggs	specialty cheeses	Wednesday	Afternoon	14	1-20 order	0
518295	2223185	199346	26	3	14	11.0	81	14	0	15	canned goods	canned jarred vegetables	Thursday	Afternoon	26	21-40 order	1
112933	325694	126540	26	4	20	7.0	69	6	0	15	canned goods	soup broth bouillon	Friday	Night	26	21-40 order	1
579731	1704510	8338	7	4	9	10.0	24	3	1	4	produce	fresh fruits	Friday	Morning	47	41-60 order	0
780543	448953	10868	28	2	8	10.0	93	1	0	3	bakery	breakfast bakery	Wednesday	Morning	40	21-40 order	1
1076747	1154159	149142	47	1	14	3.0	24	10	1	4	produce	fresh fruits	Tuesday	Afternoon	63	61-80 order	0
1629667	72039	148916	5	5	10	4.0	120	2	1	16	dairy eggs	yogurt	Saturday	Morning	46	41-60 order	0
97972	2304064	119252	5	1	15	8.0	52	18	1	1	frozen	frozen breakfast	Tuesday	Afternoon	5	1-20 order	0
621931	765626	14737	38	5	12	7.0	26	15	1	7	beverages	coffee	Saturday	Morning	64	61-80 order	0
581783	1479062	68668	8	0	16	15.0	83	17	1	4	produce	fresh vegetables	Monday	Afternoon	13	1-20 order	0

	order_id	user_id	order_number	order_dow	order_hour_of_day	days_since_prior_order	product_id	add_to_cart_order	reordered	department_id	department	product_name	day	order_time_list	max_order	order_number_group	Cluster_DBSCAN
771967	1100412	152348	2	1	11	30.0	77	8	1	7	beverages	soft drinks	Tuesday	Morning	2	1-20 order	0
1319657	2992007	113928	2	0	14	13.0	21	6	1	16	dairy eggs	packaged cheese	Monday	Afternoon	12	1-20 order	0
1040485	3231589	100011	9	0	16	11.0	24	9	0	4	produce	fresh fruits	Monday	Afternoon	9	1-20 order	1
74648	6262	124477	69	2	10	1.0	112	5	1	3	bakery	bread	Wednesday	Morning	100	81-100 order	0
60733	19199	185247	17	6	14	30.0	77	9	0	7	beverages	soft drinks	Sunday	Afternoon	17	1-20 order	1
1660186	2566034	96727	33	5	13	5.0	16	23	0	4	produce	fresh herbs	Saturday	Afternoon	33	21-40 order	1
1426863	2845299	177992	24	1	16	8.0	59	11	1	15	canned goods	canned meals beans	Tuesday	Afternoon	24	21-40 order	0
795781	2448063	119949	58	5	12	2.0	78	1	1	19	snacks	crackers	Saturday	Morning	58	41-60 order	0
1254879	2963962	169312	11	5	9	4.0	20	9	0	11	personal care	oral hygiene	Saturday	Morning	11	1-20 order	1
1758656	2421160	22593	15	0	8	29.0	83	11	1	4	produce	fresh vegetables	Monday	Morning	15	1-20 order	0

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Lowercase Letter

Dash Punctuation

Space Separator

Most occurring scripts